/*      */ package com.yc.web.importdata;
/*      */ 
/*      */ import com.yc.dao.model.AcdcDistributionBO;
/*      */ import com.yc.dao.model.AirconditionBO;
/*      */ import com.yc.dao.model.AntennaFeederBO;
/*      */ import com.yc.dao.model.BTSNewBO;
/*      */ import com.yc.dao.model.BathunderBO;
/*      */ import com.yc.dao.model.DynamoBO;
/*      */ import com.yc.dao.model.EnvMontorBO;
/*      */ import com.yc.dao.model.FiberInfoBO;
/*      */ import com.yc.dao.model.FiberUsedInfoBO;
/*      */ import com.yc.dao.model.FireExtinGuisherBO;
/*      */ import com.yc.dao.model.GeographicalenvBo;
/*      */ import com.yc.dao.model.IronTowerBO;
/*      */ import com.yc.dao.model.MachineRoomBO;
/*      */ import com.yc.dao.model.MagnifierBO;
/*      */ import com.yc.dao.model.MainssupplyBO;
/*      */ import com.yc.dao.model.PowerBoxBO;
/*      */ import com.yc.dao.model.PowerSupplyBO;
/*      */ import com.yc.dao.model.SectionInfoBo;
/*      */ import com.yc.dao.model.SectionOutInfoBO;
/*      */ import com.yc.dao.model.StoragebatteryBO;
/*      */ import com.yc.dao.model.TrafficInfoBO;
/*      */ import com.yc.dao.model.TransfersBO;
/*      */ import com.yc.dao.model.TransformerBO;
/*      */ import com.yc.dao.model.UsedFiberMapBO;
/*      */ import com.yc.util.FormatDateTime;
/*      */ import java.util.ArrayList;
/*      */ import java.util.List;
/*      */ import org.apache.commons.logging.Log;
/*      */ import org.apache.commons.logging.LogFactory;
/*      */ import org.apache.poi.hssf.usermodel.HSSFRow;
/*      */ import org.apache.poi.hssf.usermodel.HSSFSheet;
/*      */ 
/*      */ public class ImportUtil
/*      */ {
/*   38 */   private static final Log log = LogFactory.getLog(ImportUtil.class);
/*      */ 
/*      */   public static boolean isAvaliable(Object obj)
/*      */   {
/*   43 */     if ((obj != null) && (obj.toString().trim().length() > 0)) {
/*   44 */       return true;
/*      */     }
/*   46 */     return false;
/*      */   }
/*      */ 
/*      */   public static List importBtsNewData(HSSFSheet sheet) {
/*   50 */     List list = null;
/*   51 */     int rowCount = sheet.getLastRowNum();
/*   52 */     if (rowCount <= 0)
/*   53 */       return null;
/*   54 */     list = new ArrayList();
/*   55 */     HSSFRow row = null;
/*   56 */     Object objCell = null;
/*   57 */     for (int i = 7; i <= rowCount; i++) {
/*   58 */       row = sheet.getRow(i);
/*   59 */       BTSNewBO bo = new BTSNewBO();
/*   60 */       objCell = row.getCell((short)0);
/*   61 */       if (isAvaliable(objCell))
/*   62 */         bo.setId(objCell.toString());
/*   63 */       objCell = row.getCell((short)1);
/*   64 */       if (isAvaliable(objCell))
/*   65 */         bo.setBtscode(objCell.toString());
/*   66 */       objCell = row.getCell((short)2);
/*   67 */       if (isAvaliable(objCell))
/*   68 */         bo.setBtsname(objCell.toString());
/*   69 */       objCell = row.getCell((short)3);
/*   70 */       if (isAvaliable(objCell))
/*   71 */         bo.setFrequency(objCell.toString());
/*   72 */       objCell = row.getCell((short)4);
/*   73 */       if (isAvaliable(objCell))
/*   74 */         bo.setBSC(objCell.toString());
/*   75 */       objCell = row.getCell((short)5);
/*   76 */       if (isAvaliable(objCell))
/*   77 */         bo.setManufacturer(objCell.toString());
/*   78 */       objCell = row.getCell((short)6);
/*   79 */       if (isAvaliable(objCell))
/*   80 */         bo.setCabinet(objCell.toString());
/*   81 */       objCell = row.getCell((short)7);
/*   82 */       if (isAvaliable(objCell))
/*   83 */         bo.setPrimdevicetype(objCell.toString());
/*   84 */       objCell = row.getCell((short)8);
/*   85 */       if (isAvaliable(objCell))
/*   86 */         bo.setBtscfg(objCell.toString());
/*   87 */       objCell = row.getCell((short)9);
/*   88 */       if (isAvaliable(objCell))
/*   89 */         bo.setFrequencyNum(objCell.toString());
/*   90 */       objCell = row.getCell((short)10);
/*   91 */       if (isAvaliable(objCell))
/*   92 */         bo.setCombinerType(objCell.toString());
/*   93 */       objCell = row.getCell((short)11);
/*   94 */       if (isAvaliable(objCell))
/*   95 */         bo.setCombinerNum(objCell.toString());
/*   96 */       objCell = row.getCell((short)12);
/*   97 */       if (isAvaliable(objCell))
/*   98 */         bo.setPrimContrmodel(objCell.toString());
/*   99 */       objCell = row.getCell((short)13);
/*  100 */       if (isAvaliable(objCell))
/*  101 */         bo.setPrimContrNum(objCell.toString());
/*  102 */       objCell = row.getCell((short)14);
/*  103 */       if (isAvaliable(objCell))
/*  104 */         bo.setPowerPanelType(objCell.toString());
/*  105 */       objCell = row.getCell((short)15);
/*  106 */       if (isAvaliable(objCell))
/*  107 */         bo.setPowerPanelNum(objCell.toString());
/*  108 */       objCell = row.getCell((short)16);
/*  109 */       if (isAvaliable(objCell))
/*  110 */         bo.setPowerType(objCell.toString());
/*  111 */       objCell = row.getCell((short)17);
/*  112 */       if (isAvaliable(objCell))
/*  113 */         bo.setEle2Mnum(objCell.toString());
/*  114 */       objCell = row.getCell((short)18);
/*  115 */       if (isAvaliable(objCell))
/*  116 */         bo.setRegisttime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd"));
/*  117 */       objCell = row.getCell((short)19);
/*  118 */       if (isAvaliable(objCell))
/*  119 */         bo.setAntennaType(objCell.toString());
/*  120 */       objCell = row.getCell((short)20);
/*  121 */       if (isAvaliable(objCell))
/*  122 */         bo.setAntennaFac(objCell.toString());
/*  123 */       objCell = row.getCell((short)21);
/*  124 */       if (isAvaliable(objCell))
/*  125 */         bo.setAntennaNum(objCell.toString());
/*  126 */       objCell = row.getCell((short)22);
/*  127 */       if (isAvaliable(objCell))
/*  128 */         bo.setAntennaGain(objCell.toString());
/*  129 */       objCell = row.getCell((short)23);
/*  130 */       if (isAvaliable(objCell))
/*  131 */         bo.setAntennaDirect(objCell.toString());
/*  132 */       objCell = row.getCell((short)24);
/*  133 */       if (isAvaliable(objCell))
/*  134 */         bo.setAntennaPolar(objCell.toString());
/*  135 */       objCell = row.getCell((short)25);
/*  136 */       if (isAvaliable(objCell))
/*  137 */         bo.setAntennaHeight(objCell.toString());
/*  138 */       objCell = row.getCell((short)26);
/*  139 */       if (isAvaliable(objCell))
/*  140 */         bo.setAntennaPre(objCell.toString());
/*  141 */       objCell = row.getCell((short)27);
/*  142 */       if (isAvaliable(objCell))
/*  143 */         bo.setAntennaAngle(objCell.toString());
/*  144 */       objCell = row.getCell((short)28);
/*  145 */       if (isAvaliable(objCell))
/*  146 */         bo.setAntennaPitchAngle(objCell.toString());
/*  147 */       objCell = row.getCell((short)29);
/*  148 */       if (isAvaliable(objCell))
/*  149 */         bo.setFeederType(objCell.toString());
/*  150 */       objCell = row.getCell((short)30);
/*  151 */       if (isAvaliable(objCell))
/*  152 */         bo.setOther1(objCell.toString());
/*  153 */       objCell = row.getCell((short)31);
/*  154 */       if (isAvaliable(objCell))
/*  155 */         bo.setOther2(objCell.toString());
/*  156 */       objCell = row.getCell((short)32);
/*  157 */       if (isAvaliable(objCell))
/*  158 */         bo.setOther3(objCell.toString());
/*  159 */       objCell = row.getCell((short)33);
/*  160 */       if (isAvaliable(objCell))
/*  161 */         bo.setOther4(objCell.toString());
/*  162 */       objCell = row.getCell((short)34);
/*  163 */       if (isAvaliable(objCell))
/*  164 */         bo.setIDUType(objCell.toString());
/*  165 */       objCell = row.getCell((short)35);
/*  166 */       if (isAvaliable(objCell))
/*  167 */         bo.setIDUNum(objCell.toString());
/*  168 */       objCell = row.getCell((short)36);
/*  169 */       if (isAvaliable(objCell))
/*  170 */         bo.setODUType(objCell.toString());
/*  171 */       objCell = row.getCell((short)37);
/*  172 */       if (isAvaliable(objCell))
/*  173 */         bo.setODUNum(objCell.toString());
/*  174 */       objCell = row.getCell((short)38);
/*  175 */       if (isAvaliable(objCell))
/*  176 */         bo.setRefreshtime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  177 */       objCell = row.getCell((short)39);
/*  178 */       if (isAvaliable(objCell))
/*  179 */         bo.setMemo(objCell.toString());
/*  180 */       list.add(bo);
/*      */     }
/*      */ 
/*  184 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importMagnifierData(HSSFSheet sheet) {
/*  188 */     List list = null;
/*  189 */     int rowCount = sheet.getLastRowNum();
/*  190 */     if (rowCount <= 0)
/*  191 */       return null;
/*  192 */     list = new ArrayList();
/*  193 */     HSSFRow row = null;
/*  194 */     Object objCell = null;
/*  195 */     for (int i = 7; i <= rowCount; i++) {
/*  196 */       row = sheet.getRow(i);
/*  197 */       MagnifierBO bo = new MagnifierBO();
/*  198 */       objCell = row.getCell((short)0);
/*  199 */       if (isAvaliable(objCell))
/*  200 */         bo.setId(objCell.toString().trim());
/*  201 */       objCell = row.getCell((short)1);
/*  202 */       if (isAvaliable(objCell))
/*  203 */         bo.setBtscode(objCell.toString().trim());
/*  204 */       objCell = row.getCell((short)2);
/*  205 */       if (isAvaliable(objCell))
/*  206 */         bo.setBtsname(objCell.toString().trim());
/*  207 */       objCell = row.getCell((short)3);
/*  208 */       if (isAvaliable(objCell))
/*  209 */         bo.setType(objCell.toString().trim());
/*  210 */       objCell = row.getCell((short)4);
/*  211 */       if (isAvaliable(objCell))
/*  212 */         bo.setCapacity(objCell.toString().trim());
/*  213 */       objCell = row.getCell((short)5);
/*  214 */       if (isAvaliable(objCell))
/*  215 */         bo.setManufacturer(objCell.toString().trim());
/*  216 */       objCell = row.getCell((short)6);
/*  217 */       if (isAvaliable(objCell))
/*  218 */         bo.setNum(objCell.toString().trim());
/*  219 */       objCell = row.getCell((short)7);
/*  220 */       if (isAvaliable(objCell))
/*  221 */         bo.setCellU(objCell.toString().trim());
/*  222 */       objCell = row.getCell((short)8);
/*  223 */       if (isAvaliable(objCell))
/*  224 */         bo.setOpentime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd"));
/*  225 */       objCell = row.getCell((short)9);
/*  226 */       if (isAvaliable(objCell))
/*  227 */         bo.setMaintenance(objCell.toString().trim());
/*  228 */       objCell = row.getCell((short)10);
/*  229 */       if (isAvaliable(objCell))
/*  230 */         bo.setRefreshtime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  231 */       objCell = row.getCell((short)11);
/*  232 */       if (isAvaliable(objCell))
/*  233 */         bo.setMemo(objCell.toString().trim());
/*  234 */       list.add(bo);
/*      */     }
/*      */ 
/*  237 */     return list;
/*      */   }
/*      */ 
/*      */   public static List imporPowerBoxData(HSSFSheet sheet) {
/*  241 */     List list = null;
/*  242 */     int rowCount = sheet.getLastRowNum();
/*  243 */     if (rowCount <= 0)
/*  244 */       return null;
/*  245 */     list = new ArrayList();
/*  246 */     HSSFRow row = null;
/*  247 */     Object objCell = null;
/*  248 */     for (int i = 7; i <= rowCount; i++) {
/*  249 */       row = sheet.getRow(i);
/*  250 */       PowerBoxBO bo = new PowerBoxBO();
/*  251 */       objCell = row.getCell((short)0);
/*  252 */       if (isAvaliable(objCell))
/*  253 */         bo.setId(objCell.toString().trim());
/*  254 */       objCell = row.getCell((short)1);
/*  255 */       if (isAvaliable(objCell))
/*  256 */         bo.setBtscode(objCell.toString().trim());
/*  257 */       objCell = row.getCell((short)2);
/*  258 */       if (isAvaliable(objCell))
/*  259 */         bo.setBtsname(objCell.toString().trim());
/*  260 */       objCell = row.getCell((short)3);
/*  261 */       if (isAvaliable(objCell))
/*  262 */         bo.setType(objCell.toString().trim());
/*  263 */       objCell = row.getCell((short)4);
/*  264 */       if (isAvaliable(objCell))
/*  265 */         bo.setManufacturer(objCell.toString().trim());
/*  266 */       objCell = row.getCell((short)5);
/*  267 */       if (isAvaliable(objCell))
/*  268 */         bo.setNum(objCell.toString().trim());
/*  269 */       objCell = row.getCell((short)6);
/*  270 */       if (isAvaliable(objCell))
/*  271 */         bo.setDcvoltage(objCell.toString().trim());
/*  272 */       objCell = row.getCell((short)7);
/*  273 */       if (isAvaliable(objCell))
/*  274 */         bo.setOpentime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd"));
/*  275 */       objCell = row.getCell((short)8);
/*  276 */       if (isAvaliable(objCell))
/*  277 */         bo.setCommtype(objCell.toString().trim());
/*  278 */       objCell = row.getCell((short)9);
/*  279 */       if (isAvaliable(objCell))
/*  280 */         bo.setCommcapacity(objCell.toString().trim());
/*  281 */       objCell = row.getCell((short)10);
/*  282 */       if (isAvaliable(objCell))
/*  283 */         bo.setMonmodel(objCell.toString().trim());
/*  284 */       objCell = row.getCell((short)11);
/*  285 */       if (isAvaliable(objCell))
/*  286 */         bo.setMonnum(objCell.toString().trim());
/*  287 */       objCell = row.getCell((short)12);
/*  288 */       if (isAvaliable(objCell))
/*  289 */         bo.setMaintenance(objCell.toString().trim());
/*  290 */       objCell = row.getCell((short)13);
/*  291 */       if (isAvaliable(objCell))
/*  292 */         bo.setRefreshtime(FormatDateTime.toDateByString(objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  293 */       objCell = row.getCell((short)14);
/*  294 */       if (isAvaliable(objCell))
/*  295 */         bo.setMemo(objCell.toString().trim());
/*  296 */       objCell = row.getCell((short)15);
/*  297 */       if (isAvaliable(objCell))
/*  298 */         bo.setPboxOutI(objCell.toString().trim());
/*  299 */       objCell = row.getCell((short)16);
/*  300 */       if (isAvaliable(objCell))
/*  301 */         bo.setPboxNum(objCell.toString().trim());
/*  302 */       objCell = row.getCell((short)17);
/*  303 */       if (isAvaliable(objCell))
/*  304 */         bo.setPboxWorkSta(objCell.toString().trim());
/*  305 */       list.add(bo);
/*      */     }
/*  307 */     return list;
/*      */   }
/*      */ 
/*      */   public static List imporStorageBatteryData(HSSFSheet sheet)
/*      */   {
/*  312 */     List list = null;
/*  313 */     int rowCount = sheet.getLastRowNum();
/*  314 */     if (rowCount <= 0)
/*  315 */       return null;
/*  316 */     list = new ArrayList();
/*  317 */     HSSFRow row = null;
/*  318 */     Object objCell = null;
/*  319 */     for (int i = 7; i <= rowCount; i++) {
/*  320 */       row = sheet.getRow(i);
/*  321 */       StoragebatteryBO bo = new StoragebatteryBO();
/*  322 */       objCell = row.getCell((short)0);
/*  323 */       if (isAvaliable(objCell))
/*  324 */         bo.setId(objCell.toString().trim());
/*  325 */       objCell = row.getCell((short)1);
/*  326 */       if (isAvaliable(objCell))
/*  327 */         bo.setBtscode(objCell.toString().trim());
/*  328 */       objCell = row.getCell((short)2);
/*  329 */       if (isAvaliable(objCell))
/*  330 */         bo.setBtsname(objCell.toString().trim());
/*  331 */       objCell = row.getCell((short)3);
/*  332 */       if (isAvaliable(objCell))
/*  333 */         bo.setNo(objCell.toString().trim());
/*  334 */       objCell = row.getCell((short)4);
/*  335 */       if (isAvaliable(objCell)) {
/*  336 */         bo.setSwitchNo(objCell.toString().trim());
/*      */       }
/*      */ 
/*  339 */       objCell = row.getCell((short)5);
/*  340 */       if (isAvaliable(objCell))
/*  341 */         bo.setType(objCell.toString().trim());
/*  342 */       objCell = row.getCell((short)6);
/*  343 */       if (isAvaliable(objCell))
/*  344 */         bo.setManufacturer(objCell.toString().trim());
/*  345 */       objCell = row.getCell((short)7);
/*  346 */       if (isAvaliable(objCell))
/*  347 */         bo.setCapacity(objCell.toString().trim());
/*  348 */       objCell = row.getCell((short)8);
/*  349 */       if (isAvaliable(objCell))
/*  350 */         bo.setGroupnum(objCell.toString().trim());
/*  351 */       objCell = row.getCell((short)9);
/*  352 */       if (isAvaliable(objCell))
/*  353 */         bo.setBatterynum(objCell.toString().trim());
/*  354 */       objCell = row.getCell((short)10);
/*  355 */       if (isAvaliable(objCell))
/*  356 */         bo.setVoltage(objCell.toString().trim());
/*  357 */       objCell = row.getCell((short)11);
/*  358 */       if (isAvaliable(objCell))
/*  359 */         bo.setOpentime(FormatDateTime.toDateByString(
/*  360 */           objCell.toString(), "yyyy-MM-dd"));
/*  361 */       objCell = row.getCell((short)12);
/*  362 */       if (isAvaliable(objCell))
/*  363 */         bo.setDischarge(objCell.toString().trim());
/*  364 */       objCell = row.getCell((short)13);
/*  365 */       if (isAvaliable(objCell))
/*  366 */         bo.setMaintenance(objCell.toString().trim());
/*  367 */       objCell = row.getCell((short)14);
/*  368 */       if (isAvaliable(objCell))
/*  369 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  370 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  371 */       objCell = row.getCell((short)15);
/*  372 */       if (isAvaliable(objCell))
/*  373 */         bo.setMemo(objCell.toString().trim());
/*  374 */       list.add(bo);
/*      */     }
/*      */ 
/*  377 */     return list;
/*      */   }
/*      */ 
/*      */   public static List imporAirconditionData(HSSFSheet sheet) {
/*  381 */     List list = null;
/*  382 */     int rowCount = sheet.getLastRowNum();
/*  383 */     if (rowCount <= 0)
/*  384 */       return null;
/*  385 */     list = new ArrayList();
/*  386 */     HSSFRow row = null;
/*  387 */     Object objCell = null;
/*  388 */     for (int i = 7; i <= rowCount; i++) {
/*  389 */       row = sheet.getRow(i);
/*  390 */       AirconditionBO bo = new AirconditionBO();
/*  391 */       objCell = row.getCell((short)0);
/*  392 */       if (isAvaliable(objCell))
/*  393 */         bo.setId(objCell.toString().trim());
/*  394 */       objCell = row.getCell((short)1);
/*  395 */       if (isAvaliable(objCell))
/*  396 */         bo.setBtscode(objCell.toString().trim());
/*  397 */       objCell = row.getCell((short)2);
/*  398 */       if (isAvaliable(objCell))
/*  399 */         bo.setBtsname(objCell.toString().trim());
/*  400 */       objCell = row.getCell((short)3);
/*  401 */       if (isAvaliable(objCell))
/*  402 */         bo.setType(objCell.toString().trim());
/*  403 */       objCell = row.getCell((short)4);
/*  404 */       if (isAvaliable(objCell))
/*  405 */         bo.setManufacturer(objCell.toString().trim());
/*  406 */       objCell = row.getCell((short)5);
/*  407 */       if (isAvaliable(objCell))
/*  408 */         bo.setCapacity(objCell.toString().trim());
/*  409 */       objCell = row.getCell((short)6);
/*  410 */       if (isAvaliable(objCell))
/*  411 */         bo.setNum(objCell.toString().trim());
/*  412 */       objCell = row.getCell((short)7);
/*  413 */       if (isAvaliable(objCell))
/*  414 */         bo.setOpentime(FormatDateTime.toDateByString(
/*  415 */           objCell.toString(), "yyyy-MM-dd"));
/*  416 */       objCell = row.getCell((short)8);
/*  417 */       if (isAvaliable(objCell))
/*  418 */         bo.setFence(objCell.toString().trim());
/*  419 */       objCell = row.getCell((short)9);
/*  420 */       if (isAvaliable(objCell))
/*  421 */         bo.setMaintenance(objCell.toString().trim());
/*  422 */       objCell = row.getCell((short)10);
/*  423 */       if (isAvaliable(objCell))
/*  424 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  425 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  426 */       objCell = row.getCell((short)11);
/*  427 */       if (isAvaliable(objCell))
/*  428 */         bo.setMemo(objCell.toString().trim());
/*  429 */       objCell = row.getCell((short)12);
/*  430 */       if (isAvaliable(objCell))
/*  431 */         bo.setAircPowerType(objCell.toString().trim());
/*  432 */       objCell = row.getCell((short)13);
/*  433 */       if (isAvaliable(objCell))
/*  434 */         bo.setAircType(objCell.toString().trim());
/*  435 */       objCell = row.getCell((short)14);
/*  436 */       if (isAvaliable(objCell))
/*  437 */         bo.setAircInSideSize(objCell.toString().trim());
/*  438 */       objCell = row.getCell((short)15);
/*  439 */       if (isAvaliable(objCell))
/*  440 */         bo.setAircOutSideSize(objCell.toString().trim());
/*  441 */       list.add(bo);
/*      */     }
/*      */ 
/*  444 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importFireExtinGuisherData(HSSFSheet sheet)
/*      */   {
/*  449 */     List list = null;
/*  450 */     int rowCount = sheet.getLastRowNum();
/*  451 */     if (rowCount <= 0)
/*  452 */       return null;
/*  453 */     list = new ArrayList();
/*  454 */     HSSFRow row = null;
/*  455 */     Object objCell = null;
/*  456 */     for (int i = 7; i <= rowCount; i++) {
/*  457 */       row = sheet.getRow(i);
/*  458 */       FireExtinGuisherBO bo = new FireExtinGuisherBO();
/*  459 */       objCell = row.getCell((short)0);
/*  460 */       if (isAvaliable(objCell))
/*  461 */         bo.setId(objCell.toString().trim());
/*  462 */       objCell = row.getCell((short)1);
/*  463 */       if (isAvaliable(objCell))
/*  464 */         bo.setBtscode(objCell.toString().trim());
/*  465 */       objCell = row.getCell((short)2);
/*  466 */       if (isAvaliable(objCell))
/*  467 */         bo.setBtsname(objCell.toString().trim());
/*  468 */       objCell = row.getCell((short)3);
/*  469 */       if (isAvaliable(objCell))
/*  470 */         bo.setManufacturer(objCell.toString().trim());
/*  471 */       objCell = row.getCell((short)4);
/*  472 */       if (isAvaliable(objCell))
/*  473 */         bo.setType(objCell.toString().trim());
/*  474 */       objCell = row.getCell((short)5);
/*  475 */       if (isAvaliable(objCell))
/*  476 */         bo.setNum(objCell.toString().trim());
/*  477 */       objCell = row.getCell((short)6);
/*  478 */       if (isAvaliable(objCell))
/*  479 */         bo.setInwarranty(objCell.toString().trim());
/*  480 */       objCell = row.getCell((short)7);
/*  481 */       if (isAvaliable(objCell))
/*  482 */         bo.setMaintenance(objCell.toString().trim());
/*  483 */       objCell = row.getCell((short)8);
/*  484 */       if (isAvaliable(objCell))
/*  485 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  486 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  487 */       objCell = row.getCell((short)9);
/*  488 */       if (isAvaliable(objCell))
/*  489 */         bo.setMemo(objCell.toString().trim());
/*  490 */       objCell = row.getCell((short)10);
/*  491 */       if (isAvaliable(objCell))
/*  492 */         bo.setFireeType(objCell.toString().trim());
/*  493 */       objCell = row.getCell((short)11);
/*  494 */       if (isAvaliable(objCell))
/*  495 */         bo.setFireeIsEff(objCell.toString().trim());
/*  496 */       list.add(bo);
/*      */     }
/*  498 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importBathunderData(HSSFSheet sheet) {
/*  502 */     List list = null;
/*  503 */     int rowCount = sheet.getLastRowNum();
/*  504 */     if (rowCount <= 0)
/*  505 */       return null;
/*  506 */     list = new ArrayList();
/*  507 */     HSSFRow row = null;
/*  508 */     Object objCell = null;
/*  509 */     for (int i = 7; i <= rowCount; i++) {
/*  510 */       row = sheet.getRow(i);
/*  511 */       BathunderBO bo = new BathunderBO();
/*  512 */       objCell = row.getCell((short)0);
/*  513 */       if (isAvaliable(objCell))
/*  514 */         bo.setId(objCell.toString().trim());
/*  515 */       objCell = row.getCell((short)1);
/*  516 */       if (isAvaliable(objCell))
/*  517 */         bo.setBtscode(objCell.toString().trim());
/*  518 */       objCell = row.getCell((short)2);
/*  519 */       if (isAvaliable(objCell))
/*  520 */         bo.setBtsname(objCell.toString().trim());
/*  521 */       objCell = row.getCell((short)3);
/*  522 */       if (isAvaliable(objCell))
/*  523 */         bo.setType(objCell.toString().trim());
/*  524 */       objCell = row.getCell((short)4);
/*  525 */       if (isAvaliable(objCell))
/*  526 */         bo.setManufacturer(objCell.toString().trim());
/*  527 */       objCell = row.getCell((short)5);
/*  528 */       if (isAvaliable(objCell))
/*  529 */         bo.setCapacity(objCell.toString().trim());
/*  530 */       objCell = row.getCell((short)6);
/*  531 */       if (isAvaliable(objCell))
/*  532 */         bo.setNum(objCell.toString().trim());
/*  533 */       objCell = row.getCell((short)7);
/*  534 */       if (isAvaliable(objCell))
/*  535 */         bo.setOpentime(FormatDateTime.toDateByString(
/*  536 */           objCell.toString(), "yyyy-MM-dd"));
/*  537 */       objCell = row.getCell((short)8);
/*  538 */       if (isAvaliable(objCell))
/*  539 */         bo.setMaintenance(objCell.toString().trim());
/*  540 */       objCell = row.getCell((short)9);
/*  541 */       if (isAvaliable(objCell))
/*  542 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  543 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  544 */       objCell = row.getCell((short)10);
/*  545 */       if (isAvaliable(objCell))
/*  546 */         bo.setMemo(objCell.toString().trim());
/*  547 */       objCell = row.getCell((short)11);
/*  548 */       if (isAvaliable(objCell))
/*  549 */         bo.setHunderPowerType(objCell.toString().trim());
/*  550 */       objCell = row.getCell((short)12);
/*  551 */       if (isAvaliable(objCell))
/*  552 */         bo.setHunderWorkSta(objCell.toString().trim());
/*  553 */       objCell = row.getCell((short)13);
/*  554 */       if (isAvaliable(objCell))
/*  555 */         bo.setHunderLineLen(objCell.toString().trim());
/*  556 */       list.add(bo);
/*      */     }
/*      */ 
/*  559 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importEnvMontorData(HSSFSheet sheet)
/*      */   {
/*  564 */     List list = null;
/*  565 */     int rowCount = sheet.getLastRowNum();
/*  566 */     if (rowCount <= 0)
/*  567 */       return null;
/*  568 */     list = new ArrayList();
/*  569 */     HSSFRow row = null;
/*  570 */     Object objCell = null;
/*  571 */     for (int i = 7; i <= rowCount; i++) {
/*  572 */       row = sheet.getRow(i);
/*  573 */       EnvMontorBO bo = new EnvMontorBO();
/*  574 */       objCell = row.getCell((short)0);
/*  575 */       if (isAvaliable(objCell))
/*  576 */         bo.setId(objCell.toString().trim());
/*  577 */       objCell = row.getCell((short)1);
/*  578 */       if (isAvaliable(objCell))
/*  579 */         bo.setBtscode(objCell.toString().trim());
/*  580 */       objCell = row.getCell((short)2);
/*  581 */       if (isAvaliable(objCell))
/*  582 */         bo.setBtsname(objCell.toString().trim());
/*  583 */       objCell = row.getCell((short)3);
/*  584 */       if (isAvaliable(objCell))
/*  585 */         bo.setType(objCell.toString().trim());
/*  586 */       objCell = row.getCell((short)4);
/*  587 */       if (isAvaliable(objCell))
/*  588 */         bo.setManufacturer(objCell.toString().trim());
/*  589 */       objCell = row.getCell((short)5);
/*  590 */       if (isAvaliable(objCell))
/*  591 */         bo.setMonobj(objCell.toString().trim());
/*  592 */       objCell = row.getCell((short)6);
/*  593 */       if (isAvaliable(objCell))
/*  594 */         bo.setTransType(objCell.toString().trim());
/*  595 */       objCell = row.getCell((short)7);
/*  596 */       if (isAvaliable(objCell))
/*  597 */         bo.setTransPort(objCell.toString().trim());
/*  598 */       objCell = row.getCell((short)8);
/*  599 */       if (isAvaliable(objCell))
/*  600 */         bo.setOpentime(FormatDateTime.toDateByString(
/*  601 */           objCell.toString(), "yyyy-MM-dd"));
/*  602 */       objCell = row.getCell((short)9);
/*  603 */       if (isAvaliable(objCell))
/*  604 */         bo.setMaintenance(objCell.toString().trim());
/*  605 */       objCell = row.getCell((short)10);
/*  606 */       if (isAvaliable(objCell))
/*  607 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  608 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  609 */       objCell = row.getCell((short)11);
/*  610 */       if (isAvaliable(objCell))
/*  611 */         bo.setMemo(objCell.toString().trim());
/*  612 */       objCell = row.getCell((short)12);
/*  613 */       if (isAvaliable(objCell))
/*  614 */         bo.setMonWorkSta(objCell.toString().trim());
/*  615 */       list.add(bo);
/*      */     }
/*      */ 
/*  618 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importDynamoData(HSSFSheet sheet)
/*      */   {
/*  623 */     List list = null;
/*  624 */     int rowCount = sheet.getLastRowNum();
/*  625 */     if (rowCount <= 0)
/*  626 */       return null;
/*  627 */     list = new ArrayList();
/*  628 */     HSSFRow row = null;
/*  629 */     Object objCell = null;
/*  630 */     for (int i = 7; i <= rowCount; i++) {
/*  631 */       row = sheet.getRow(i);
/*  632 */       DynamoBO bo = new DynamoBO();
/*  633 */       objCell = row.getCell((short)0);
/*  634 */       if (isAvaliable(objCell))
/*  635 */         bo.setId(objCell.toString().trim());
/*  636 */       objCell = row.getCell((short)1);
/*  637 */       if (isAvaliable(objCell))
/*  638 */         bo.setBtscode(objCell.toString().trim());
/*  639 */       objCell = row.getCell((short)2);
/*  640 */       if (isAvaliable(objCell))
/*  641 */         bo.setBtsname(objCell.toString().trim());
/*  642 */       objCell = row.getCell((short)3);
/*  643 */       if (isAvaliable(objCell))
/*  644 */         bo.setDynamoHouse(objCell.toString().trim());
/*  645 */       objCell = row.getCell((short)4);
/*  646 */       if (isAvaliable(objCell))
/*  647 */         bo.setManufacturer(objCell.toString().trim());
/*  648 */       objCell = row.getCell((short)5);
/*  649 */       if (isAvaliable(objCell))
/*  650 */         bo.setType(objCell.toString().trim());
/*  651 */       objCell = row.getCell((short)6);
/*  652 */       if (isAvaliable(objCell))
/*  653 */         bo.setModel(objCell.toString().trim());
/*  654 */       objCell = row.getCell((short)7);
/*  655 */       if (isAvaliable(objCell))
/*  656 */         bo.setPower(objCell.toString().trim());
/*  657 */       objCell = row.getCell((short)8);
/*  658 */       if (isAvaliable(objCell))
/*  659 */         bo.setAutoboot(objCell.toString().trim());
/*  660 */       objCell = row.getCell((short)9);
/*  661 */       if (isAvaliable(objCell))
/*  662 */         bo.setConsumption(objCell.toString().trim());
/*  663 */       objCell = row.getCell((short)10);
/*  664 */       if (isAvaliable(objCell))
/*  665 */         bo.setSumtime(objCell.toString().trim());
/*  666 */       objCell = row.getCell((short)11);
/*  667 */       if (isAvaliable(objCell))
/*  668 */         bo.setMaintenance(objCell.toString().trim());
/*  669 */       objCell = row.getCell((short)12);
/*  670 */       if (isAvaliable(objCell))
/*  671 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  672 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  673 */       objCell = row.getCell((short)13);
/*  674 */       if (isAvaliable(objCell))
/*  675 */         bo.setMemo(objCell.toString().trim());
/*  676 */       objCell = row.getCell((short)14);
/*  677 */       if (isAvaliable(objCell))
/*  678 */         bo.setDynamoIsStatic(objCell.toString().trim());
/*  679 */       objCell = row.getCell((short)15);
/*  680 */       if (isAvaliable(objCell))
/*  681 */         bo.setDanymoSeiral(objCell.toString().trim());
/*  682 */       objCell = row.getCell((short)16);
/*  683 */       if (isAvaliable(objCell))
/*  684 */         bo.setDynamoWorkLen(objCell.toString().trim());
/*  685 */       objCell = row.getCell((short)17);
/*  686 */       if (isAvaliable(objCell))
/*  687 */         bo.setDynamoMaintainRec(objCell.toString().trim());
/*  688 */       list.add(bo);
/*      */     }
/*      */ 
/*  691 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importAcdcDistributionData(HSSFSheet sheet) {
/*  695 */     List list = null;
/*  696 */     int rowCount = sheet.getLastRowNum();
/*  697 */     if (rowCount <= 0)
/*  698 */       return null;
/*  699 */     list = new ArrayList();
/*  700 */     HSSFRow row = null;
/*  701 */     Object objCell = null;
/*  702 */     for (int i = 7; i <= rowCount; i++) {
/*  703 */       row = sheet.getRow(i);
/*  704 */       AcdcDistributionBO bo = new AcdcDistributionBO();
/*  705 */       objCell = row.getCell((short)0);
/*  706 */       if (isAvaliable(objCell))
/*  707 */         bo.setId(objCell.toString().trim());
/*  708 */       objCell = row.getCell((short)1);
/*  709 */       if (isAvaliable(objCell))
/*  710 */         bo.setBtscode(objCell.toString().trim());
/*  711 */       objCell = row.getCell((short)2);
/*  712 */       if (isAvaliable(objCell))
/*  713 */         bo.setBtsname(objCell.toString().trim());
/*  714 */       objCell = row.getCell((short)3);
/*  715 */       if (isAvaliable(objCell))
/*  716 */         bo.setDistmanufacturer(objCell.toString().trim());
/*  717 */       objCell = row.getCell((short)4);
/*  718 */       if (isAvaliable(objCell))
/*  719 */         bo.setDisttype(objCell.toString().trim());
/*  720 */       objCell = row.getCell((short)5);
/*  721 */       if (isAvaliable(objCell))
/*  722 */         bo.setDistother(objCell.toString().trim());
/*  723 */       objCell = row.getCell((short)6);
/*  724 */       if (isAvaliable(objCell))
/*  725 */         bo.setAirswitchM(objCell.toString().trim());
/*  726 */       objCell = row.getCell((short)7);
/*  727 */       if (isAvaliable(objCell))
/*  728 */         bo.setAirswitchT(objCell.toString().trim());
/*  729 */       objCell = row.getCell((short)8);
/*  730 */       if (isAvaliable(objCell))
/*  731 */         bo.setAirswitchC(objCell.toString().trim());
/*  732 */       objCell = row.getCell((short)9);
/*  733 */       if (isAvaliable(objCell))
/*  734 */         bo.setAirswitchO(objCell.toString().trim());
/*  735 */       objCell = row.getCell((short)10);
/*  736 */       if (isAvaliable(objCell))
/*  737 */         bo.setAirswitchCRD(objCell.toString().trim());
/*  738 */       objCell = row.getCell((short)11);
/*  739 */       if (isAvaliable(objCell))
/*  740 */         bo.setElecableDAS(objCell.toString().trim());
/*  741 */       objCell = row.getCell((short)12);
/*  742 */       if (isAvaliable(objCell))
/*  743 */         bo.setElecableDAT(objCell.toString().trim());
/*  744 */       objCell = row.getCell((short)13);
/*  745 */       if (isAvaliable(objCell))
/*  746 */         bo.setElecableDANum(objCell.toString().trim());
/*  747 */       objCell = row.getCell((short)14);
/*  748 */       if (isAvaliable(objCell))
/*  749 */         bo.setElecableDALen(objCell.toString().trim());
/*  750 */       objCell = row.getCell((short)15);
/*  751 */       if (isAvaliable(objCell))
/*  752 */         bo.setElecableDACRD(objCell.toString().trim());
/*  753 */       objCell = row.getCell((short)16);
/*  754 */       if (isAvaliable(objCell))
/*  755 */         bo.setRegulatorM(objCell.toString().trim());
/*  756 */       objCell = row.getCell((short)17);
/*  757 */       if (isAvaliable(objCell))
/*  758 */         bo.setRegulatorT(objCell.toString().trim());
/*  759 */       objCell = row.getCell((short)18);
/*  760 */       if (isAvaliable(objCell))
/*  761 */         bo.setRegulatorC(objCell.toString().trim());
/*  762 */       objCell = row.getCell((short)19);
/*  763 */       if (isAvaliable(objCell))
/*  764 */         bo.setRegulatorOT(FormatDateTime.toDateByString(
/*  765 */           objCell.toString(), "yyyy-MM-dd"));
/*  766 */       objCell = row.getCell((short)20);
/*  767 */       if (isAvaliable(objCell))
/*  768 */         bo.setRegulatorCRD(objCell.toString().trim());
/*  769 */       objCell = row.getCell((short)21);
/*  770 */       if (isAvaliable(objCell))
/*  771 */         bo.setLighting(objCell.toString().trim());
/*  772 */       objCell = row.getCell((short)22);
/*  773 */       if (isAvaliable(objCell))
/*  774 */         bo.setSocket(objCell.toString().trim());
/*  775 */       objCell = row.getCell((short)23);
/*  776 */       if (isAvaliable(objCell))
/*  777 */         bo.setElecableCPS(objCell.toString().trim());
/*  778 */       objCell = row.getCell((short)24);
/*  779 */       if (isAvaliable(objCell))
/*  780 */         bo.setElecableCPT(objCell.toString().trim());
/*  781 */       objCell = row.getCell((short)25);
/*  782 */       if (isAvaliable(objCell))
/*  783 */         bo.setElecableCPNum(objCell.toString().trim());
/*  784 */       objCell = row.getCell((short)26);
/*  785 */       if (isAvaliable(objCell))
/*  786 */         bo.setElecableCPLen(objCell.toString().trim());
/*  787 */       objCell = row.getCell((short)27);
/*  788 */       if (isAvaliable(objCell))
/*  789 */         bo.setElecableCPCRD(objCell.toString().trim());
/*  790 */       objCell = row.getCell((short)28);
/*  791 */       if (isAvaliable(objCell))
/*  792 */         bo.setDDConverterT(objCell.toString().trim());
/*  793 */       objCell = row.getCell((short)29);
/*  794 */       if (isAvaliable(objCell))
/*  795 */         bo.setDDConverterM(objCell.toString().trim());
/*  796 */       objCell = row.getCell((short)30);
/*  797 */       if (isAvaliable(objCell))
/*  798 */         bo.setDDConverterNum(objCell.toString().trim());
/*  799 */       objCell = row.getCell((short)31);
/*  800 */       if (isAvaliable(objCell))
/*  801 */         bo.setDDConverterC(objCell.toString().trim());
/*  802 */       objCell = row.getCell((short)32);
/*  803 */       if (isAvaliable(objCell))
/*  804 */         bo.setDDConverterOT(FormatDateTime.toDateByString(
/*  805 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  806 */       objCell = row.getCell((short)33);
/*  807 */       if (isAvaliable(objCell))
/*  808 */         bo.setDDConverterCRD(objCell.toString().trim());
/*  809 */       objCell = row.getCell((short)34);
/*  810 */       if (isAvaliable(objCell))
/*  811 */         bo.setDDisplayT(objCell.toString().trim());
/*  812 */       objCell = row.getCell((short)35);
/*  813 */       if (isAvaliable(objCell))
/*  814 */         bo.setDDisplayM(objCell.toString().trim());
/*  815 */       objCell = row.getCell((short)36);
/*  816 */       if (isAvaliable(objCell))
/*  817 */         bo.setDDisplayNum(objCell.toString().trim());
/*  818 */       objCell = row.getCell((short)37);
/*  819 */       if (isAvaliable(objCell))
/*  820 */         bo.setDDisplayC(objCell.toString().trim());
/*  821 */       objCell = row.getCell((short)38);
/*  822 */       if (isAvaliable(objCell))
/*  823 */         bo.setDDisplayOT(FormatDateTime.toDateByString(
/*  824 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  825 */       objCell = row.getCell((short)39);
/*  826 */       if (isAvaliable(objCell))
/*  827 */         bo.setMaintenance(objCell.toString().trim());
/*  828 */       objCell = row.getCell((short)40);
/*  829 */       if (isAvaliable(objCell))
/*  830 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  831 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  832 */       objCell = row.getCell((short)41);
/*  833 */       if (isAvaliable(objCell))
/*  834 */         bo.setMemo(objCell.toString().trim());
/*  835 */       list.add(bo);
/*      */     }
/*  837 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importTransformerData(HSSFSheet sheet)
/*      */   {
/*  842 */     List list = null;
/*  843 */     int rowCount = sheet.getLastRowNum();
/*  844 */     if (rowCount <= 0)
/*  845 */       return null;
/*  846 */     list = new ArrayList();
/*  847 */     HSSFRow row = null;
/*  848 */     Object objCell = null;
/*  849 */     for (int i = 7; i <= rowCount; i++) {
/*  850 */       row = sheet.getRow(i);
/*  851 */       TransformerBO bo = new TransformerBO();
/*  852 */       objCell = row.getCell((short)0);
/*  853 */       if (isAvaliable(objCell))
/*  854 */         bo.setId(objCell.toString().trim());
/*  855 */       objCell = row.getCell((short)1);
/*  856 */       if (isAvaliable(objCell))
/*  857 */         bo.setBtscode(objCell.toString().trim());
/*  858 */       objCell = row.getCell((short)2);
/*  859 */       if (isAvaliable(objCell))
/*  860 */         bo.setBtsname(objCell.toString().trim());
/*  861 */       objCell = row.getCell((short)3);
/*  862 */       if (isAvaliable(objCell))
/*  863 */         bo.setModel(objCell.toString().trim());
/*  864 */       objCell = row.getCell((short)4);
/*  865 */       if (isAvaliable(objCell))
/*  866 */         bo.setCapacity(objCell.toString().trim());
/*  867 */       objCell = row.getCell((short)5);
/*  868 */       if (isAvaliable(objCell))
/*  869 */         bo.setManufacturer(objCell.toString().trim());
/*  870 */       objCell = row.getCell((short)6);
/*  871 */       if (isAvaliable(objCell))
/*  872 */         bo.setProperty(objCell.toString().trim());
/*  873 */       objCell = row.getCell((short)7);
/*  874 */       if (isAvaliable(objCell))
/*  875 */         bo.setMaintenance(objCell.toString().trim());
/*  876 */       objCell = row.getCell((short)8);
/*  877 */       if (isAvaliable(objCell))
/*  878 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/*  879 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/*  880 */       objCell = row.getCell((short)9);
/*  881 */       if (isAvaliable(objCell))
/*  882 */         bo.setMemo(objCell.toString().trim());
/*  883 */       objCell = row.getCell((short)10);
/*  884 */       if (isAvaliable(objCell))
/*  885 */         bo.setTranPowerType(objCell.toString().trim());
/*  886 */       objCell = row.getCell((short)11);
/*  887 */       if (isAvaliable(objCell))
/*  888 */         bo.setTranMaintain(objCell.toString().trim());
/*  889 */       objCell = row.getCell((short)12);
/*  890 */       if (isAvaliable(objCell))
/*  891 */         bo.setTranHighLen(objCell.toString().trim());
/*  892 */       objCell = row.getCell((short)13);
/*  893 */       if (isAvaliable(objCell))
/*  894 */         bo.setTranLowLen(objCell.toString().trim());
/*  895 */       objCell = row.getCell((short)14);
/*  896 */       if (isAvaliable(objCell))
/*  897 */         bo.setTranRValue(objCell.toString().trim());
/*  898 */       objCell = row.getCell((short)15);
/*  899 */       if (isAvaliable(objCell))
/*  900 */         bo.setTranStartTime(objCell.toString().trim());
/*  901 */       list.add(bo);
/*      */     }
/*  903 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForTransfersData(HSSFSheet sheet) {
/*  907 */     List list = null;
/*  908 */     int rowCount = sheet.getLastRowNum();
/*  909 */     if (rowCount <= 0)
/*  910 */       return null;
/*  911 */     list = new ArrayList();
/*  912 */     HSSFRow row = null;
/*  913 */     Object objCell = null;
/*  914 */     for (int i = 7; i <= rowCount; i++) {
/*  915 */       row = sheet.getRow(i);
/*  916 */       TransfersBO bo = new TransfersBO();
/*  917 */       objCell = row.getCell((short)0);
/*  918 */       if (isAvaliable(objCell))
/*  919 */         bo.setId(objCell.toString().trim());
/*  920 */       objCell = row.getCell((short)1);
/*  921 */       if (isAvaliable(objCell))
/*  922 */         bo.setBtscode(objCell.toString().trim());
/*  923 */       objCell = row.getCell((short)2);
/*  924 */       if (isAvaliable(objCell))
/*  925 */         bo.setBtsname(objCell.toString().trim());
/*  926 */       objCell = row.getCell((short)3);
/*  927 */       if (isAvaliable(objCell))
/*  928 */         bo.setTransAF(objCell.toString().trim());
/*  929 */       objCell = row.getCell((short)4);
/*  930 */       if (isAvaliable(objCell))
/*  931 */         bo.setSDHAF(objCell.toString().trim());
/*  932 */       objCell = row.getCell((short)5);
/*  933 */       if (isAvaliable(objCell))
/*  934 */         bo.setPDHAF(objCell.toString().trim());
/*  935 */       objCell = row.getCell((short)6);
/*  936 */       if (isAvaliable(objCell))
/*  937 */         bo.setMicrowaveAF(objCell.toString().trim());
/*  938 */       objCell = row.getCell((short)7);
/*  939 */       if (isAvaliable(objCell))
/*  940 */         bo.setOtherAF(objCell.toString().trim());
/*  941 */       objCell = row.getCell((short)8);
/*  942 */       if (isAvaliable(objCell))
/*  943 */         bo.setSDHAM(objCell.toString().trim());
/*  944 */       objCell = row.getCell((short)9);
/*  945 */       if (isAvaliable(objCell))
/*  946 */         bo.setPDHAM(objCell.toString().trim());
/*  947 */       objCell = row.getCell((short)10);
/*  948 */       if (isAvaliable(objCell))
/*  949 */         bo.setMicrowaveAM(objCell.toString().trim());
/*  950 */       objCell = row.getCell((short)11);
/*  951 */       if (isAvaliable(objCell))
/*  952 */         bo.setOtherAM(objCell.toString().trim());
/*  953 */       objCell = row.getCell((short)12);
/*  954 */       if (isAvaliable(objCell))
/*  955 */         bo.setVoltageA(objCell.toString().trim());
/*  956 */       objCell = row.getCell((short)13);
/*  957 */       if (isAvaliable(objCell))
/*  958 */         bo.setPropertyA(objCell.toString().trim());
/*  959 */       objCell = row.getCell((short)14);
/*  960 */       if (isAvaliable(objCell))
/*  961 */         bo.setOpentimeA(FormatDateTime.toDateByString(
/*  962 */           objCell.toString(), "yyyy-MM-dd"));
/*  963 */       objCell = row.getCell((short)15);
/*  964 */       if (isAvaliable(objCell))
/*  965 */         bo.setDistODFAF(objCell.toString().trim());
/*  966 */       objCell = row.getCell((short)16);
/*  967 */       if (isAvaliable(objCell))
/*  968 */         bo.setDistDDFAF(objCell.toString().trim());
/*  969 */       objCell = row.getCell((short)17);
/*  970 */       if (isAvaliable(objCell))
/*  971 */         bo.setDistcomtankAF(objCell.toString().trim());
/*  972 */       objCell = row.getCell((short)18);
/*  973 */       if (isAvaliable(objCell))
/*  974 */         bo.setDistotherAF(objCell.toString().trim());
/*  975 */       objCell = row.getCell((short)19);
/*  976 */       if (isAvaliable(objCell))
/*  977 */         bo.setDistODFAM(objCell.toString().trim());
/*  978 */       objCell = row.getCell((short)20);
/*  979 */       if (isAvaliable(objCell))
/*  980 */         bo.setDistDDFAM(objCell.toString().trim());
/*  981 */       objCell = row.getCell((short)21);
/*  982 */       if (isAvaliable(objCell))
/*  983 */         bo.setDistcomtankAM(objCell.toString().trim());
/*  984 */       objCell = row.getCell((short)22);
/*  985 */       if (isAvaliable(objCell))
/*  986 */         bo.setDistotherAM(objCell.toString().trim());
/*  987 */       objCell = row.getCell((short)23);
/*  988 */       if (isAvaliable(objCell))
/*  989 */         bo.setEle2MCNum(objCell.toString().trim());
/*  990 */       objCell = row.getCell((short)24);
/*  991 */       if (isAvaliable(objCell))
/*  992 */         bo.setEle2MUNum(objCell.toString().trim());
/*  993 */       objCell = row.getCell((short)25);
/*  994 */       if (isAvaliable(objCell))
/*  995 */         bo.setEle2MAUNum(objCell.toString().trim());
/*  996 */       objCell = row.getCell((short)26);
/*  997 */       if (isAvaliable(objCell))
/*  998 */         bo.setEle2MUidx(objCell.toString().trim());
/*  999 */       objCell = row.getCell((short)27);
/* 1000 */       if (isAvaliable(objCell))
/* 1001 */         bo.setEle2MUTimeSlot(objCell.toString().trim());
/* 1002 */       objCell = row.getCell((short)28);
/* 1003 */       if (isAvaliable(objCell))
/* 1004 */         bo.setMaintenance(objCell.toString().trim());
/* 1005 */       objCell = row.getCell((short)29);
/* 1006 */       if (isAvaliable(objCell))
/* 1007 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1008 */           objCell.toString(), "yyyy-MM-dd"));
/* 1009 */       objCell = row.getCell((short)30);
/* 1010 */       if (isAvaliable(objCell))
/* 1011 */         bo.setMemo(objCell.toString().trim());
/* 1012 */       objCell = row.getCell((short)31);
/* 1013 */       if (isAvaliable(objCell))
/* 1014 */         bo.setStr2MUseSta(objCell.toString().trim());
/* 1015 */       objCell = row.getCell((short)32);
/* 1016 */       if (isAvaliable(objCell))
/* 1017 */         bo.setIsPowerAlone(objCell.toString().trim());
/* 1018 */       list.add(bo);
/*      */     }
/*      */ 
/* 1022 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForMainssupplyData(HSSFSheet sheet)
/*      */   {
/* 1027 */     List list = null;
/* 1028 */     int rowCount = sheet.getLastRowNum();
/* 1029 */     if (rowCount <= 0)
/* 1030 */       return null;
/* 1031 */     list = new ArrayList();
/* 1032 */     HSSFRow row = null;
/* 1033 */     Object objCell = null;
/* 1034 */     for (int i = 7; i <= rowCount; i++) {
/* 1035 */       row = sheet.getRow(i);
/* 1036 */       MainssupplyBO bo = new MainssupplyBO();
/*      */ 
/* 1038 */       int j = 0;
/* 1039 */       objCell = row.getCell((short)j++);
/* 1040 */       if (isAvaliable(objCell))
/* 1041 */         bo.setId(objCell.toString().trim());
/* 1042 */       objCell = row.getCell((short)j++);
/* 1043 */       if (isAvaliable(objCell))
/* 1044 */         bo.setBtscode(objCell.toString().trim());
/* 1045 */       objCell = row.getCell((short)j++);
/* 1046 */       if (isAvaliable(objCell))
/* 1047 */         bo.setBtsname(objCell.toString().trim());
/* 1048 */       objCell = row.getCell((short)j++);
/* 1049 */       if (isAvaliable(objCell))
/* 1050 */         bo.setType(objCell.toString().trim());
/* 1051 */       objCell = row.getCell((short)j++);
/* 1052 */       if (isAvaliable(objCell))
/* 1053 */         bo.setElecableTDLen(objCell.toString().trim());
/* 1054 */       objCell = row.getCell((short)j++);
/* 1055 */       if (isAvaliable(objCell))
/* 1056 */         bo.setElecableTDM(objCell.toString().trim());
/* 1057 */       objCell = row.getCell((short)j++);
/* 1058 */       if (isAvaliable(objCell))
/* 1059 */         bo.setElecableTDT(objCell.toString().trim());
/* 1060 */       objCell = row.getCell((short)j++);
/* 1061 */       if (isAvaliable(objCell))
/* 1062 */         bo.setElecableTDP(objCell.toString().trim());
/* 1063 */       objCell = row.getCell((short)j++);
/* 1064 */       if (isAvaliable(objCell))
/* 1065 */         bo.setElecableLDLen(objCell.toString().trim());
/* 1066 */       objCell = row.getCell((short)j++);
/* 1067 */       if (isAvaliable(objCell))
/* 1068 */         bo.setElecableLDM(objCell.toString().trim());
/* 1069 */       objCell = row.getCell((short)j++);
/* 1070 */       if (isAvaliable(objCell))
/* 1071 */         bo.setElecableLDT(objCell.toString().trim());
/* 1072 */       objCell = row.getCell((short)j++);
/* 1073 */       if (isAvaliable(objCell))
/* 1074 */         bo.setElecableLDP(objCell.toString().trim());
/* 1075 */       objCell = row.getCell((short)j++);
/* 1076 */       if (isAvaliable(objCell))
/* 1077 */         bo.setMaintenance(objCell.toString().trim());
/* 1078 */       objCell = row.getCell((short)j++);
/* 1079 */       if (isAvaliable(objCell))
/* 1080 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1081 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1082 */       objCell = row.getCell((short)j++);
/* 1083 */       if (isAvaliable(objCell))
/* 1084 */         bo.setMemo(objCell.toString().trim());
/* 1085 */       list.add(bo);
/*      */     }
/*      */ 
/* 1088 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForAntennaFeederData(HSSFSheet sheet)
/*      */   {
/* 1093 */     List list = null;
/* 1094 */     int rowCount = sheet.getLastRowNum();
/* 1095 */     if (rowCount <= 0)
/* 1096 */       return null;
/* 1097 */     list = new ArrayList();
/* 1098 */     HSSFRow row = null;
/* 1099 */     Object objCell = null;
/* 1100 */     for (int i = 7; i <= rowCount; i++) {
/* 1101 */       row = sheet.getRow(i);
/* 1102 */       AntennaFeederBO bo = new AntennaFeederBO();
/* 1103 */       int j = 0;
/* 1104 */       objCell = row.getCell((short)j++);
/* 1105 */       if (isAvaliable(objCell))
/* 1106 */         bo.setId(objCell.toString().trim());
/* 1107 */       objCell = row.getCell((short)j++);
/* 1108 */       if (isAvaliable(objCell))
/* 1109 */         bo.setBtscode(objCell.toString().trim());
/* 1110 */       objCell = row.getCell((short)j++);
/* 1111 */       if (isAvaliable(objCell))
/* 1112 */         bo.setBtsname(objCell.toString().trim());
/* 1113 */       objCell = row.getCell((short)j++);
/* 1114 */       if (isAvaliable(objCell))
/* 1115 */         bo.setAntennaT(objCell.toString().trim());
/* 1116 */       objCell = row.getCell((short)j++);
/* 1117 */       if (isAvaliable(objCell))
/* 1118 */         bo.setAntennaM(objCell.toString().trim());
/* 1119 */       objCell = row.getCell((short)j++);
/* 1120 */       if (isAvaliable(objCell))
/* 1121 */         bo.setAntennaNum(objCell.toString().trim());
/* 1122 */       objCell = row.getCell((short)j++);
/* 1123 */       if (isAvaliable(objCell))
/* 1124 */         bo.setAntennaPlu(objCell.toString().trim());
/* 1125 */       objCell = row.getCell((short)j++);
/* 1126 */       if (isAvaliable(objCell))
/* 1127 */         bo.setAntennaDir(objCell.toString().trim());
/* 1128 */       objCell = row.getCell((short)j++);
/* 1129 */       if (isAvaliable(objCell))
/* 1130 */         bo.setAntennaPT(objCell.toString().trim());
/* 1131 */       objCell = row.getCell((short)j++);
/* 1132 */       if (isAvaliable(objCell))
/* 1133 */         bo.setAntennaFB(objCell.toString().trim());
/* 1134 */       objCell = row.getCell((short)j++);
/* 1135 */       if (isAvaliable(objCell))
/* 1136 */         bo.setAntennaH(objCell.toString().trim());
/* 1137 */       objCell = row.getCell((short)j++);
/* 1138 */       if (isAvaliable(objCell))
/* 1139 */         bo.setAntennaCRD(objCell.toString().trim());
/* 1140 */       objCell = row.getCell((short)j++);
/* 1141 */       if (isAvaliable(objCell))
/* 1142 */         bo.setMagnifierT(objCell.toString().trim());
/* 1143 */       objCell = row.getCell((short)j++);
/* 1144 */       if (isAvaliable(objCell))
/* 1145 */         bo.setMagnifierM(objCell.toString().trim());
/* 1146 */       objCell = row.getCell((short)j++);
/* 1147 */       if (isAvaliable(objCell))
/* 1148 */         bo.setMagnifierNum(objCell.toString().trim());
/* 1149 */       objCell = row.getCell((short)j++);
/* 1150 */       if (isAvaliable(objCell))
/* 1151 */         bo.setMagnifierCell(objCell.toString().trim());
/* 1152 */       objCell = row.getCell((short)j++);
/* 1153 */       if (isAvaliable(objCell))
/* 1154 */         bo.setMagnifierCRD(objCell.toString().trim());
/* 1155 */       objCell = row.getCell((short)j++);
/* 1156 */       if (isAvaliable(objCell))
/* 1157 */         bo.setFeederT(objCell.toString().trim());
/* 1158 */       objCell = row.getCell((short)j++);
/* 1159 */       if (isAvaliable(objCell))
/* 1160 */         bo.setFeederM(objCell.toString().trim());
/* 1161 */       objCell = row.getCell((short)j++);
/* 1162 */       if (isAvaliable(objCell))
/* 1163 */         bo.setFeederLen(objCell.toString().trim());
/* 1164 */       objCell = row.getCell((short)j++);
/* 1165 */       if (isAvaliable(objCell))
/* 1166 */         bo.setFeederNum(objCell.toString().trim());
/* 1167 */       objCell = row.getCell((short)j++);
/* 1168 */       if (isAvaliable(objCell))
/* 1169 */         bo.setMaintenance(objCell.toString().trim());
/* 1170 */       objCell = row.getCell((short)j++);
/* 1171 */       if (isAvaliable(objCell))
/* 1172 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1173 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1174 */       objCell = row.getCell((short)j++);
/* 1175 */       if (isAvaliable(objCell))
/* 1176 */         bo.setMemo(objCell.toString().trim());
/* 1177 */       objCell = row.getCell((short)j++);
/* 1178 */       if (isAvaliable(objCell))
/* 1179 */         bo.setAnteIsMakeAng(objCell.toString().trim());
/* 1180 */       objCell = row.getCell((short)j++);
/* 1181 */       if (isAvaliable(objCell))
/* 1182 */         bo.setAnteDicAng(objCell.toString().trim());
/* 1183 */       objCell = row.getCell((short)j++);
/* 1184 */       if (isAvaliable(objCell)) {
/* 1185 */         bo.setAnteUpAng(objCell.toString().trim());
/*      */       }
/* 1187 */       list.add(bo);
/*      */     }
/*      */ 
/* 1190 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForIronTowerData(HSSFSheet sheet)
/*      */   {
/* 1195 */     List list = null;
/* 1196 */     int rowCount = sheet.getLastRowNum();
/* 1197 */     if (rowCount <= 0)
/* 1198 */       return null;
/* 1199 */     list = new ArrayList();
/* 1200 */     HSSFRow row = null;
/* 1201 */     Object objCell = null;
/* 1202 */     int j = 0;
/* 1203 */     for (int i = 7; i <= rowCount; i++) {
/* 1204 */       row = sheet.getRow(i);
/* 1205 */       IronTowerBO bo = new IronTowerBO();
/* 1206 */       j = 0;
/* 1207 */       objCell = row.getCell((short)j++);
/* 1208 */       if (isAvaliable(objCell))
/* 1209 */         bo.setId(objCell.toString().trim());
/* 1210 */       objCell = row.getCell((short)j++);
/* 1211 */       if (isAvaliable(objCell))
/* 1212 */         bo.setBtscode(objCell.toString().trim());
/* 1213 */       objCell = row.getCell((short)j++);
/* 1214 */       if (isAvaliable(objCell))
/* 1215 */         bo.setBtsname(objCell.toString().trim());
/* 1216 */       objCell = row.getCell((short)j++);
/* 1217 */       if (isAvaliable(objCell))
/* 1218 */         bo.setProperty(objCell.toString().trim());
/* 1219 */       objCell = row.getCell((short)j++);
/* 1220 */       if (isAvaliable(objCell))
/* 1221 */         bo.setOpentime(FormatDateTime.toDateByString(
/* 1222 */           objCell.toString(), "yyyy-MM-dd"));
/* 1223 */       objCell = row.getCell((short)j++);
/* 1224 */       if (isAvaliable(objCell))
/* 1225 */         bo.setFromunit(objCell.toString().trim());
/* 1226 */       objCell = row.getCell((short)j++);
/* 1227 */       if (isAvaliable(objCell))
/* 1228 */         bo.setContact(objCell.toString().trim());
/* 1229 */       objCell = row.getCell((short)j++);
/* 1230 */       if (isAvaliable(objCell))
/* 1231 */         bo.setTelphone(objCell.toString().trim());
/* 1232 */       objCell = row.getCell((short)j++);
/* 1233 */       if (isAvaliable(objCell))
/* 1234 */         bo.setType(objCell.toString().trim());
/* 1235 */       objCell = row.getCell((short)j++);
/* 1236 */       if (isAvaliable(objCell))
/* 1237 */         bo.setHeight(objCell.toString().trim());
/* 1238 */       objCell = row.getCell((short)j++);
/* 1239 */       if (isAvaliable(objCell))
/* 1240 */         bo.setWarnschilder(objCell.toString().trim());
/* 1241 */       objCell = row.getCell((short)j++);
/* 1242 */       if (isAvaliable(objCell))
/* 1243 */         bo.setMaintenance(objCell.toString().trim());
/* 1244 */       objCell = row.getCell((short)j++);
/* 1245 */       if (isAvaliable(objCell))
/* 1246 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1247 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1248 */       objCell = row.getCell((short)j++);
/* 1249 */       if (isAvaliable(objCell))
/* 1250 */         bo.setMemo(objCell.toString().trim());
/* 1251 */       objCell = row.getCell((short)j++);
/* 1252 */       if (isAvaliable(objCell))
/* 1253 */         bo.setItowerPlatNum(objCell.toString().trim());
/* 1254 */       objCell = row.getCell((short)j++);
/* 1255 */       if (isAvaliable(objCell)) {
/* 1256 */         bo.setItowerSta(objCell.toString().trim());
/*      */       }
/* 1258 */       list.add(bo);
/*      */     }
/*      */ 
/* 1261 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForMachineRoomData(HSSFSheet sheet)
/*      */   {
/* 1266 */     List list = null;
/* 1267 */     int rowCount = sheet.getLastRowNum();
/* 1268 */     if (rowCount <= 0)
/* 1269 */       return null;
/* 1270 */     list = new ArrayList();
/* 1271 */     HSSFRow row = null;
/* 1272 */     Object objCell = null;
/* 1273 */     int j = 0;
/* 1274 */     for (int i = 7; i <= rowCount; i++) {
/* 1275 */       row = sheet.getRow(i);
/* 1276 */       MachineRoomBO bo = new MachineRoomBO();
/* 1277 */       j = 0;
/* 1278 */       objCell = row.getCell((short)j++);
/* 1279 */       if (isAvaliable(objCell))
/* 1280 */         bo.setId(objCell.toString().trim());
/* 1281 */       objCell = row.getCell((short)j++);
/* 1282 */       if (isAvaliable(objCell))
/* 1283 */         bo.setBtscode(objCell.toString().trim());
/* 1284 */       objCell = row.getCell((short)j++);
/* 1285 */       if (isAvaliable(objCell))
/* 1286 */         bo.setBtsname(objCell.toString().trim());
/* 1287 */       objCell = row.getCell((short)j++);
/* 1288 */       if (isAvaliable(objCell))
/* 1289 */         bo.setFrame(objCell.toString().trim());
/* 1290 */       objCell = row.getCell((short)j++);
/* 1291 */       if (isAvaliable(objCell))
/* 1292 */         bo.setAcreageT(objCell.toString().trim());
/* 1293 */       objCell = row.getCell((short)j++);
/* 1294 */       if (isAvaliable(objCell))
/* 1295 */         bo.setPlan(objCell.toString().trim());
/* 1296 */       objCell = row.getCell((short)j++);
/* 1297 */       if (isAvaliable(objCell))
/* 1298 */         bo.setProperty(objCell.toString().trim());
/* 1299 */       objCell = row.getCell((short)j++);
/* 1300 */       if (isAvaliable(objCell))
/* 1301 */         bo.setFromunit(objCell.toString().trim());
/* 1302 */       objCell = row.getCell((short)j++);
/* 1303 */       if (isAvaliable(objCell))
/* 1304 */         bo.setOther(objCell.toString().trim());
/* 1305 */       objCell = row.getCell((short)j++);
/* 1306 */       if (isAvaliable(objCell))
/* 1307 */         bo.setContact(objCell.toString().trim());
/* 1308 */       objCell = row.getCell((short)j++);
/* 1309 */       if (isAvaliable(objCell))
/* 1310 */         bo.setTelphone(objCell.toString().trim());
/* 1311 */       objCell = row.getCell((short)j++);
/* 1312 */       if (isAvaliable(objCell))
/* 1313 */         bo.setOpentime(FormatDateTime.toDateByString(
/* 1314 */           objCell.toString(), "yyyy-MM-dd"));
/* 1315 */       objCell = row.getCell((short)j++);
/* 1316 */       if (isAvaliable(objCell))
/* 1317 */         bo.setWallheight(objCell.toString().trim());
/* 1318 */       objCell = row.getCell((short)j++);
/* 1319 */       if (isAvaliable(objCell))
/* 1320 */         bo.setDoortype(objCell.toString().trim());
/* 1321 */       objCell = row.getCell((short)j++);
/* 1322 */       if (isAvaliable(objCell))
/* 1323 */         bo.setFacility(objCell.toString().trim());
/* 1324 */       objCell = row.getCell((short)j++);
/* 1325 */       if (isAvaliable(objCell))
/* 1326 */         bo.setReason(objCell.toString().trim());
/* 1327 */       objCell = row.getCell((short)j++);
/* 1328 */       if (isAvaliable(objCell))
/* 1329 */         bo.setWarnschilder(objCell.toString().trim());
/* 1330 */       objCell = row.getCell((short)j++);
/* 1331 */       if (isAvaliable(objCell))
/* 1332 */         bo.setAcreageU(objCell.toString().trim());
/* 1333 */       objCell = row.getCell((short)j++);
/* 1334 */       if (isAvaliable(objCell))
/* 1335 */         bo.setPlace(objCell.toString().trim());
/* 1336 */       objCell = row.getCell((short)j++);
/* 1337 */       if (isAvaliable(objCell))
/* 1338 */         bo.setMaintenance(objCell.toString().trim());
/* 1339 */       objCell = row.getCell((short)j++);
/* 1340 */       if (isAvaliable(objCell))
/* 1341 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1342 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1343 */       objCell = row.getCell((short)j++);
/* 1344 */       if (isAvaliable(objCell))
/* 1345 */         bo.setMemo(objCell.toString().trim());
/* 1346 */       objCell = row.getCell((short)j++);
/* 1347 */       if (isAvaliable(objCell))
/* 1348 */         bo.setMroomIsLook(objCell.toString().trim());
/* 1349 */       objCell = row.getCell((short)j++);
/* 1350 */       if (isAvaliable(objCell)) {
/* 1351 */         bo.setMroomLookTel(objCell.toString().trim());
/*      */       }
/* 1353 */       list.add(bo);
/*      */     }
/*      */ 
/* 1357 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForPowerSupplyData(HSSFSheet sheet)
/*      */   {
/* 1362 */     List list = null;
/* 1363 */     int rowCount = sheet.getLastRowNum();
/* 1364 */     if (rowCount <= 0)
/* 1365 */       return null;
/* 1366 */     list = new ArrayList();
/* 1367 */     HSSFRow row = null;
/* 1368 */     Object objCell = null;
/* 1369 */     int j = 0;
/* 1370 */     for (int i = 7; i <= rowCount; i++) {
/* 1371 */       row = sheet.getRow(i);
/* 1372 */       PowerSupplyBO bo = new PowerSupplyBO();
/* 1373 */       j = 0;
/* 1374 */       objCell = row.getCell((short)j++);
/* 1375 */       if (isAvaliable(objCell))
/* 1376 */         bo.setId(objCell.toString().trim());
/* 1377 */       objCell = row.getCell((short)j++);
/* 1378 */       if (isAvaliable(objCell))
/* 1379 */         bo.setBtscode(objCell.toString().trim());
/* 1380 */       objCell = row.getCell((short)j++);
/* 1381 */       if (isAvaliable(objCell))
/* 1382 */         bo.setBtsname(objCell.toString().trim());
/* 1383 */       objCell = row.getCell((short)j++);
/* 1384 */       if (isAvaliable(objCell))
/* 1385 */         bo.setPowersupply(objCell.toString().trim());
/* 1386 */       objCell = row.getCell((short)j++);
/* 1387 */       if (isAvaliable(objCell))
/* 1388 */         bo.setPstelephone(objCell.toString().trim());
/* 1389 */       objCell = row.getCell((short)j++);
/* 1390 */       if (isAvaliable(objCell))
/* 1391 */         bo.setContact(objCell.toString().trim());
/* 1392 */       objCell = row.getCell((short)j++);
/* 1393 */       if (isAvaliable(objCell))
/* 1394 */         bo.setTelephone(objCell.toString().trim());
/* 1395 */       objCell = row.getCell((short)j++);
/* 1396 */       if (isAvaliable(objCell))
/* 1397 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1398 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1399 */       objCell = row.getCell((short)j++);
/* 1400 */       if (isAvaliable(objCell)) {
/* 1401 */         bo.setMemo(objCell.toString().trim());
/*      */       }
/* 1403 */       list.add(bo);
/*      */     }
/*      */ 
/* 1407 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForTrafficInfoData(HSSFSheet sheet)
/*      */   {
/* 1412 */     List list = null;
/* 1413 */     int rowCount = sheet.getLastRowNum();
/* 1414 */     if (rowCount <= 0)
/* 1415 */       return null;
/* 1416 */     list = new ArrayList();
/* 1417 */     HSSFRow row = null;
/* 1418 */     Object objCell = null;
/* 1419 */     int j = 0;
/* 1420 */     for (int i = 7; i <= rowCount; i++) {
/* 1421 */       row = sheet.getRow(i);
/* 1422 */       TrafficInfoBO bo = new TrafficInfoBO();
/* 1423 */       j = 0;
/* 1424 */       objCell = row.getCell((short)j++);
/* 1425 */       if (isAvaliable(objCell))
/* 1426 */         bo.setId(objCell.toString().trim());
/* 1427 */       objCell = row.getCell((short)j++);
/* 1428 */       if (isAvaliable(objCell))
/* 1429 */         bo.setBtscode(objCell.toString().trim());
/* 1430 */       objCell = row.getCell((short)j++);
/* 1431 */       if (isAvaliable(objCell))
/* 1432 */         bo.setBtsname(objCell.toString().trim());
/* 1433 */       objCell = row.getCell((short)j++);
/* 1434 */       if (isAvaliable(objCell))
/* 1435 */         bo.setRoadway(objCell.toString().trim());
/* 1436 */       objCell = row.getCell((short)j++);
/* 1437 */       if (isAvaliable(objCell))
/* 1438 */         bo.setRoad(objCell.toString().trim());
/* 1439 */       objCell = row.getCell((short)j++);
/* 1440 */       if (isAvaliable(objCell))
/* 1441 */         bo.setDistanceC(objCell.toString().trim());
/* 1442 */       objCell = row.getCell((short)j++);
/* 1443 */       if (isAvaliable(objCell))
/* 1444 */         bo.setArrivaltimeC(objCell.toString().trim());
/* 1445 */       objCell = row.getCell((short)j++);
/* 1446 */       if (isAvaliable(objCell))
/* 1447 */         bo.setDistanceP(objCell.toString().trim());
/* 1448 */       objCell = row.getCell((short)j++);
/* 1449 */       if (isAvaliable(objCell))
/* 1450 */         bo.setArrivaltimeP(objCell.toString().trim());
/* 1451 */       objCell = row.getCell((short)j++);
/* 1452 */       if (isAvaliable(objCell))
/* 1453 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1454 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1455 */       objCell = row.getCell((short)j++);
/* 1456 */       if (isAvaliable(objCell)) {
/* 1457 */         bo.setMemo(objCell.toString().trim());
/*      */       }
/* 1459 */       list.add(bo);
/*      */     }
/*      */ 
/* 1463 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForEnvData(HSSFSheet sheet) {
/* 1467 */     List list = null;
/* 1468 */     int rowCount = sheet.getLastRowNum();
/* 1469 */     if (rowCount <= 0)
/* 1470 */       return null;
/* 1471 */     list = new ArrayList();
/* 1472 */     HSSFRow row = null;
/* 1473 */     Object objCell = null;
/* 1474 */     int j = 0;
/* 1475 */     for (int i = 7; i <= rowCount; i++) {
/* 1476 */       row = sheet.getRow(i);
/* 1477 */       GeographicalenvBo bo = new GeographicalenvBo();
/*      */ 
/* 1479 */       j = 0;
/* 1480 */       objCell = row.getCell((short)j++);
/* 1481 */       if (isAvaliable(objCell))
/* 1482 */         bo.setBtscode(objCell.toString().trim());
/* 1483 */       objCell = row.getCell((short)j++);
/* 1484 */       if (isAvaliable(objCell))
/* 1485 */         bo.setBtsname(objCell.toString().trim());
/* 1486 */       objCell = row.getCell((short)j++);
/* 1487 */       if (isAvaliable(objCell))
/* 1488 */         bo.setBtszone(objCell.toString().trim());
/* 1489 */       objCell = row.getCell((short)j++);
/* 1490 */       if (isAvaliable(objCell))
/* 1491 */         bo.setLandform(objCell.toString().trim());
/* 1492 */       objCell = row.getCell((short)j++);
/* 1493 */       if (isAvaliable(objCell))
/* 1494 */         bo.setLng(objCell.toString().trim());
/* 1495 */       objCell = row.getCell((short)j++);
/* 1496 */       if (isAvaliable(objCell))
/* 1497 */         bo.setLat(objCell.toString().trim());
/* 1498 */       objCell = row.getCell((short)j++);
/* 1499 */       if (isAvaliable(objCell))
/* 1500 */         bo.setRelocationrd(objCell.toString().trim());
/* 1501 */       objCell = row.getCell((short)j++);
/* 1502 */       if (isAvaliable(objCell))
/* 1503 */         bo.setUsername(objCell.toString().trim());
/* 1504 */       objCell = row.getCell((short)j++);
/* 1505 */       if (isAvaliable(objCell))
/* 1506 */         bo.setDistcode(objCell.toString().trim());
/* 1507 */       objCell = row.getCell((short)j++);
/* 1508 */       if (isAvaliable(objCell))
/* 1509 */         bo.setBtslevel(objCell.toString().trim());
/* 1510 */       objCell = row.getCell((short)j++);
/* 1511 */       if (isAvaliable(objCell))
/* 1512 */         bo.setWorkingradius(objCell.toString().trim());
/* 1513 */       objCell = row.getCell((short)j++);
/* 1514 */       if (isAvaliable(objCell))
/* 1515 */         bo.setGraphDeatilAddr(objCell.toString().trim());
/* 1516 */       objCell = row.getCell((short)j++);
/* 1517 */       if (isAvaliable(objCell))
/* 1518 */         bo.setGraphHigh(objCell.toString().trim());
/* 1519 */       objCell = row.getCell((short)j++);
/* 1520 */       if (isAvaliable(objCell))
/* 1521 */         bo.setTrannetid(objCell.toString().trim());
/* 1522 */       objCell = row.getCell((short)j++);
/* 1523 */       if (isAvaliable(objCell))
/* 1524 */         bo.setTrannetname(objCell.toString().trim());
/* 1525 */       objCell = row.getCell((short)j++);
/* 1526 */       if (isAvaliable(objCell))
/* 1527 */         bo.setTrannetgrade(objCell.toString().trim());
/* 1528 */       objCell = row.getCell((short)j++);
/* 1529 */       if (isAvaliable(objCell))
/* 1530 */         bo.setRegisttime(FormatDateTime.toDateByString(
/* 1531 */           objCell.toString(), "yyyy-MM-dd"));
/* 1532 */       objCell = row.getCell((short)j++);
/* 1533 */       if (isAvaliable(objCell))
/* 1534 */         bo.setBtskind(objCell.toString().trim());
/* 1535 */       objCell = row.getCell((short)j++);
/* 1536 */       if (isAvaliable(objCell)) {
/* 1537 */         bo.setBtstype(objCell.toString().trim());
/*      */       }
/* 1539 */       objCell = row.getCell((short)j++);
/* 1540 */       if (isAvaliable(objCell))
/* 1541 */         bo.setCoverage(objCell.toString().trim());
/* 1542 */       objCell = row.getCell((short)j++);
/* 1543 */       if (isAvaliable(objCell))
/* 1544 */         bo.setMaintype(objCell.toString().trim());
/* 1545 */       objCell = row.getCell((short)j++);
/* 1546 */       if (isAvaliable(objCell))
/* 1547 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1548 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1549 */       objCell = row.getCell((short)j++);
/* 1550 */       if (isAvaliable(objCell))
/* 1551 */         bo.setMemo(objCell.toString().trim());
/* 1552 */       list.add(bo);
/*      */     }
/*      */ 
/* 1555 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForSectionTotalInfoData(HSSFSheet sheet)
/*      */   {
/* 1560 */     List list = null;
/* 1561 */     int rowCount = sheet.getLastRowNum();
/* 1562 */     if (rowCount <= 0)
/* 1563 */       return null;
/* 1564 */     list = new ArrayList();
/* 1565 */     HSSFRow row = null;
/* 1566 */     Object objCell = null;
/* 1567 */     int j = 0;
/* 1568 */     for (int i = 7; i <= rowCount; i++) {
/* 1569 */       row = sheet.getRow(i);
/* 1570 */       SectionInfoBo bo = new SectionInfoBo();
/*      */ 
/* 1572 */       j = 0;
/* 1573 */       objCell = row.getCell((short)j++);
/* 1574 */       if (isAvaliable(objCell))
/* 1575 */         bo.setOcID(objCell.toString().trim());
/* 1576 */       objCell = row.getCell((short)j++);
/* 1577 */       if (isAvaliable(objCell))
/* 1578 */         bo.setOcName(objCell.toString().trim());
/* 1579 */       objCell = row.getCell((short)j++);
/* 1580 */       if (isAvaliable(objCell))
/* 1581 */         bo.setOcBeginName(objCell.toString().trim());
/* 1582 */       objCell = row.getCell((short)j++);
/* 1583 */       if (isAvaliable(objCell))
/* 1584 */         bo.setOcBeginLng(objCell.toString().trim());
/* 1585 */       objCell = row.getCell((short)j++);
/* 1586 */       if (isAvaliable(objCell))
/* 1587 */         bo.setOcBeginLat(objCell.toString().trim());
/* 1588 */       objCell = row.getCell((short)j++);
/* 1589 */       if (isAvaliable(objCell))
/* 1590 */         bo.setOcEndName(objCell.toString().trim());
/* 1591 */       objCell = row.getCell((short)j++);
/* 1592 */       if (isAvaliable(objCell))
/* 1593 */         bo.setOcEndLng(objCell.toString().trim());
/* 1594 */       objCell = row.getCell((short)j++);
/* 1595 */       if (isAvaliable(objCell))
/* 1596 */         bo.setOcEndLat(objCell.toString().trim());
/* 1597 */       objCell = row.getCell((short)j++);
/* 1598 */       if (isAvaliable(objCell))
/* 1599 */         bo.setOcType(objCell.toString().trim());
/* 1600 */       objCell = row.getCell((short)j++);
/* 1601 */       if (isAvaliable(objCell))
/* 1602 */         bo.setOcNum(objCell.toString().trim());
/* 1603 */       objCell = row.getCell((short)j++);
/* 1604 */       if (isAvaliable(objCell))
/* 1605 */         bo.setOcLength(objCell.toString().trim());
/* 1606 */       objCell = row.getCell((short)j++);
/* 1607 */       if (isAvaliable(objCell))
/* 1608 */         bo.setOcInspectorName(objCell.toString().trim());
/* 1609 */       objCell = row.getCell((short)j++);
/* 1610 */       if (isAvaliable(objCell))
/* 1611 */         bo.setOcInspectorPhone(objCell.toString().trim());
/* 1612 */       objCell = row.getCell((short)j++);
/* 1613 */       if (isAvaliable(objCell))
/* 1614 */         bo.setNotes(objCell.toString().trim());
/* 1615 */       objCell = row.getCell((short)j++);
/* 1616 */       if (isAvaliable(objCell))
/* 1617 */         bo.setRefreshtime(FormatDateTime.toDateByString(
/* 1618 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1619 */       objCell = row.getCell((short)j++);
/* 1620 */       if (isAvaliable(objCell))
/* 1621 */         bo.setUserId(objCell.toString().trim());
/* 1622 */       list.add(bo);
/*      */     }
/*      */ 
/* 1625 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForFiberInfoData(HSSFSheet sheet) {
/* 1629 */     List list = null;
/* 1630 */     int rowCount = sheet.getLastRowNum();
/* 1631 */     if (rowCount <= 0)
/* 1632 */       return null;
/* 1633 */     list = new ArrayList();
/* 1634 */     HSSFRow row = null;
/* 1635 */     Object objCell = null;
/* 1636 */     int j = 0;
/* 1637 */     for (int i = 7; i <= rowCount; i++) {
/* 1638 */       row = sheet.getRow(i);
/* 1639 */       FiberInfoBO bo = new FiberInfoBO();
/*      */ 
/* 1641 */       j = 0;
/* 1642 */       objCell = row.getCell((short)j++);
/* 1643 */       if (isAvaliable(objCell))
/* 1644 */         bo.setFiberid(objCell.toString().trim());
/* 1645 */       objCell = row.getCell((short)j++);
/* 1646 */       if (isAvaliable(objCell))
/* 1647 */         bo.setOcid(objCell.toString().trim());
/* 1648 */       objCell = row.getCell((short)j++);
/* 1649 */       if (isAvaliable(objCell))
/* 1650 */         bo.setOcName(objCell.toString().trim());
/* 1651 */       objCell = row.getCell((short)j++);
/* 1652 */       if (isAvaliable(objCell))
/* 1653 */         bo.setBtsName(objCell.toString().trim());
/* 1654 */       objCell = row.getCell((short)j++);
/* 1655 */       if (isAvaliable(objCell))
/* 1656 */         bo.setOcLayType(objCell.toString().trim());
/* 1657 */       objCell = row.getCell((short)j++);
/* 1658 */       if (isAvaliable(objCell))
/* 1659 */         bo.setOcNum(Double.valueOf(objCell.toString().trim()).intValue());
/* 1660 */       objCell = row.getCell((short)j++);
/* 1661 */       if (isAvaliable(objCell))
/* 1662 */         bo.setOcLength(Double.parseDouble(objCell.toString().trim()));
/* 1663 */       objCell = row.getCell((short)j++);
/* 1664 */       if (isAvaliable(objCell))
/* 1665 */         bo.setWavelength(Double.parseDouble(objCell.toString().trim()));
/* 1666 */       objCell = row.getCell((short)j++);
/* 1667 */       if (isAvaliable(objCell))
/* 1668 */         bo.setRefractive(Double.parseDouble(objCell.toString().trim()));
/* 1669 */       objCell = row.getCell((short)j++);
/* 1670 */       if (isAvaliable(objCell))
/* 1671 */         bo.setInstrumentName(objCell.toString().trim());
/* 1672 */       objCell = row.getCell((short)j++);
/* 1673 */       if (isAvaliable(objCell))
/* 1674 */         bo.setPost(objCell.toString().trim());
/* 1675 */       objCell = row.getCell((short)j++);
/* 1676 */       if (isAvaliable(objCell))
/* 1677 */         bo.setTester(objCell.toString().trim());
/* 1678 */       objCell = row.getCell((short)j++);
/* 1679 */       if (isAvaliable(objCell)) {
/* 1680 */         bo.setTestTime(objCell.toString());
/*      */       }
/* 1682 */       list.add(bo);
/*      */     }
/*      */ 
/* 1685 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importForOutInfoData(HSSFSheet sheet) {
/* 1689 */     List list = null;
/* 1690 */     int rowCount = sheet.getLastRowNum();
/* 1691 */     if (rowCount <= 0)
/* 1692 */       return null;
/* 1693 */     list = new ArrayList();
/* 1694 */     HSSFRow row = null;
/* 1695 */     Object objCell = null;
/* 1696 */     int j = 0;
/* 1697 */     for (int i = 7; i <= rowCount; i++) {
/* 1698 */       row = sheet.getRow(i);
/* 1699 */       SectionOutInfoBO bo = new SectionOutInfoBO();
/*      */ 
/* 1701 */       j = 0;
/* 1702 */       objCell = row.getCell((short)j++);
/* 1703 */       if (isAvaliable(objCell))
/* 1704 */         bo.setId(objCell.toString().trim());
/* 1705 */       objCell = row.getCell((short)j++);
/* 1706 */       if (isAvaliable(objCell))
/* 1707 */         bo.setOutOrder(Double.valueOf(objCell.toString().trim()).intValue());
/* 1708 */       objCell = row.getCell((short)j++);
/* 1709 */       if (isAvaliable(objCell))
/* 1710 */         bo.setOcid(objCell.toString().trim());
/* 1711 */       objCell = row.getCell((short)j++);
/* 1712 */       if (isAvaliable(objCell))
/* 1713 */         bo.setOcName(objCell.toString().trim());
/* 1714 */       objCell = row.getCell((short)j++);
/* 1715 */       if (isAvaliable(objCell))
/* 1716 */         bo.setPoleNum(objCell.toString().trim());
/* 1717 */       objCell = row.getCell((short)j++);
/* 1718 */       if (isAvaliable(objCell))
/* 1719 */         bo.setPropertyRight(objCell.toString().trim());
/* 1720 */       objCell = row.getCell((short)j++);
/* 1721 */       if (isAvaliable(objCell))
/* 1722 */         bo.setLongleath1(objCell.toString().trim());
/* 1723 */       objCell = row.getCell((short)j++);
/* 1724 */       if (isAvaliable(objCell)) {
/* 1725 */         bo.setLongleath2(objCell.toString().trim());
/*      */       }
/* 1727 */       objCell = row.getCell((short)j++);
/* 1728 */       if (isAvaliable(objCell))
/* 1729 */         bo.setLng(objCell.toString().trim());
/* 1730 */       objCell = row.getCell((short)j++);
/* 1731 */       if (isAvaliable(objCell))
/* 1732 */         bo.setLat(objCell.toString().trim());
/* 1733 */       objCell = row.getCell((short)j++);
/* 1734 */       if (isAvaliable(objCell))
/* 1735 */         bo.setDistance(objCell.toString().trim());
/* 1736 */       objCell = row.getCell((short)j++);
/* 1737 */       if (isAvaliable(objCell))
/* 1738 */         bo.setIsNode(objCell.toString().trim());
/* 1739 */       objCell = row.getCell((short)j++);
/* 1740 */       if (isAvaliable(objCell))
/* 1741 */         bo.setIsRes(objCell.toString().trim());
/* 1742 */       objCell = row.getCell((short)j++);
/* 1743 */       if (isAvaliable(objCell))
/* 1744 */         bo.setResLength(objCell.toString().trim());
/* 1745 */       objCell = row.getCell((short)j++);
/* 1746 */       if (isAvaliable(objCell))
/* 1747 */         bo.setGranularity(objCell.toString().trim());
/* 1748 */       objCell = row.getCell((short)j++);
/* 1749 */       if (isAvaliable(objCell))
/* 1750 */         bo.setIsJoint(objCell.toString().trim());
/* 1751 */       objCell = row.getCell((short)j++);
/* 1752 */       if (isAvaliable(objCell))
/* 1753 */         bo.setOcLayType(objCell.toString().trim());
/* 1754 */       objCell = row.getCell((short)j++);
/* 1755 */       if (isAvaliable(objCell))
/* 1756 */         bo.setRouteInfo(objCell.toString().trim());
/* 1757 */       objCell = row.getCell((short)j++);
/* 1758 */       if (isAvaliable(objCell))
/* 1759 */         bo.setLightningprotection(objCell.toString().trim());
/* 1760 */       objCell = row.getCell((short)j++);
/* 1761 */       if (isAvaliable(objCell))
/* 1762 */         bo.setWiredrawing(objCell.toString().trim());
/* 1763 */       objCell = row.getCell((short)j++);
/* 1764 */       if (isAvaliable(objCell))
/* 1765 */         bo.setStrutnum(objCell.toString().trim());
/* 1766 */       objCell = row.getCell((short)j++);
/* 1767 */       if (isAvaliable(objCell))
/* 1768 */         bo.setZone(objCell.toString().trim());
/* 1769 */       objCell = row.getCell((short)j++);
/* 1770 */       if (isAvaliable(objCell))
/* 1771 */         bo.setUpdateTime(FormatDateTime.toDateByString(
/* 1772 */           objCell.toString(), "yyyy-MM-dd HH:mm:ss"));
/* 1773 */       list.add(bo);
/*      */     }
/*      */ 
/* 1776 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importFiberUsedInfoData(HSSFSheet sheet)
/*      */   {
/* 1781 */     List list = null;
/* 1782 */     int rowCount = sheet.getLastRowNum();
/* 1783 */     if (rowCount <= 0)
/* 1784 */       return null;
/* 1785 */     list = new ArrayList();
/* 1786 */     HSSFRow row = null;
/* 1787 */     Object objCell = null;
/* 1788 */     int j = 0;
/* 1789 */     for (int i = 7; i <= rowCount; i++) {
/* 1790 */       row = sheet.getRow(i);
/* 1791 */       FiberUsedInfoBO bo = new FiberUsedInfoBO();
/*      */ 
/* 1793 */       j = 0;
/* 1794 */       objCell = row.getCell((short)j++);
/* 1795 */       if (isAvaliable(objCell))
/* 1796 */         bo.setId(objCell.toString().trim());
/* 1797 */       objCell = row.getCell((short)j++);
/* 1798 */       if (isAvaliable(objCell))
/* 1799 */         bo.setNo(objCell.toString().trim());
/* 1800 */       objCell = row.getCell((short)j++);
/* 1801 */       if (isAvaliable(objCell))
/* 1802 */         bo.setFiberid(objCell.toString().trim());
/* 1803 */       objCell = row.getCell((short)j++);
/* 1804 */       if (isAvaliable(objCell))
/* 1805 */         bo.setTestDirection(objCell.toString().trim());
/* 1806 */       objCell = row.getCell((short)j++);
/* 1807 */       if (isAvaliable(objCell))
/* 1808 */         bo.setDecibel(Double.parseDouble(objCell.toString().trim()));
/* 1809 */       objCell = row.getCell((short)j++);
/* 1810 */       if (isAvaliable(objCell))
/* 1811 */         bo.setAllDb(Double.parseDouble(objCell.toString().trim()));
/* 1812 */       objCell = row.getCell((short)j++);
/* 1813 */       if (isAvaliable(objCell))
/* 1814 */         bo.setBeginPosition(objCell.toString().trim());
/* 1815 */       objCell = row.getCell((short)j++);
/* 1816 */       if (isAvaliable(objCell))
/* 1817 */         bo.setBeginMachineType(objCell.toString().trim());
/* 1818 */       objCell = row.getCell((short)j++);
/* 1819 */       if (isAvaliable(objCell))
/* 1820 */         bo.setDirection(objCell.toString().trim());
/* 1821 */       objCell = row.getCell((short)j++);
/* 1822 */       if (isAvaliable(objCell))
/* 1823 */         bo.setEndPosition(objCell.toString().trim());
/* 1824 */       objCell = row.getCell((short)j++);
/* 1825 */       if (isAvaliable(objCell))
/* 1826 */         bo.setEndMachineType(objCell.toString().trim());
/* 1827 */       list.add(bo);
/*      */     }
/*      */ 
/* 1830 */     return list;
/*      */   }
/*      */ 
/*      */   public static List importUsedFiberMapData(HSSFSheet sheet)
/*      */   {
/* 1835 */     List list = null;
/* 1836 */     int rowCount = sheet.getLastRowNum();
/* 1837 */     if (rowCount <= 0)
/* 1838 */       return null;
/* 1839 */     list = new ArrayList();
/* 1840 */     HSSFRow row = null;
/* 1841 */     Object objCell = null;
/* 1842 */     int j = 0;
/* 1843 */     for (int i = 7; i <= rowCount; i++) {
/* 1844 */       row = sheet.getRow(i);
/* 1845 */       UsedFiberMapBO bo = new UsedFiberMapBO();
/*      */ 
/* 1847 */       j = 0;
/* 1848 */       objCell = row.getCell((short)j++);
/* 1849 */       if (isAvaliable(objCell))
/* 1850 */         bo.setId(objCell.toString().trim());
/* 1851 */       objCell = row.getCell((short)j++);
/* 1852 */       if (isAvaliable(objCell))
/* 1853 */         bo.setOcid(objCell.toString().trim());
/* 1854 */       objCell = row.getCell((short)j++);
/* 1855 */       if (isAvaliable(objCell))
/* 1856 */         bo.setOcName(objCell.toString().trim());
/* 1857 */       objCell = row.getCell((short)j++);
/* 1858 */       if (isAvaliable(objCell))
/* 1859 */         bo.setA_netid(objCell.toString().trim());
/* 1860 */       objCell = row.getCell((short)j++);
/* 1861 */       if (isAvaliable(objCell))
/* 1862 */         bo.setA_panelid(objCell.toString().trim());
/* 1863 */       objCell = row.getCell((short)j++);
/* 1864 */       if (isAvaliable(objCell))
/* 1865 */         bo.setA_fiber_id(objCell.toString().trim());
/* 1866 */       objCell = row.getCell((short)j++);
/* 1867 */       if (isAvaliable(objCell))
/* 1868 */         bo.setA_usedinfo(objCell.toString().trim());
/* 1869 */       objCell = row.getCell((short)j++);
/* 1870 */       if (isAvaliable(objCell))
/* 1871 */         bo.setB_netid(objCell.toString().trim());
/* 1872 */       objCell = row.getCell((short)j++);
/* 1873 */       if (isAvaliable(objCell))
/* 1874 */         bo.setB_panelid(objCell.toString().trim());
/* 1875 */       objCell = row.getCell((short)j++);
/* 1876 */       if (isAvaliable(objCell))
/* 1877 */         bo.setB_fiber_id(objCell.toString().trim());
/* 1878 */       objCell = row.getCell((short)j++);
/* 1879 */       if (isAvaliable(objCell))
/* 1880 */         bo.setB_usedinfo(objCell.toString().trim());
/* 1881 */       objCell = row.getCell((short)j++);
/* 1882 */       if (isAvaliable(objCell))
/* 1883 */         bo.setA_station(objCell.toString().trim());
/* 1884 */       objCell = row.getCell((short)j++);
/* 1885 */       if (isAvaliable(objCell))
/* 1886 */         bo.setB_station(objCell.toString().trim());
/* 1887 */       objCell = row.getCell((short)j++);
/* 1888 */       if (isAvaliable(objCell))
/* 1889 */         bo.setDirection(objCell.toString().trim());
/* 1890 */       list.add(bo);
/*      */     }
/*      */ 
/* 1893 */     return list;
/*      */   }
/*      */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.web.importdata.ImportUtil
 * JD-Core Version:    0.6.2
 */